package com.ls.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.ls.entity.Holiday;
import com.ls.entity.Linkman;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 联系人 Mapper 接口
 * </p>
 *
 * @author pengyu
 * @since 2024-10-12
 */
public interface LinkmanMapper extends BaseMapper<Linkman> {

    //    /**
//     * 查询联系人列表，包含部门名称和标签名称
//     * @param queryWrapper 查询条件
//     * @return 联系人列表
//     */
//    @Select("SELECT l.*, t.team_name, lb.label_name " +
//            "FROM linkman l " +
//            "LEFT JOIN team t ON l.team_id = t.team_id AND t.valid_flag = 1 " +
//            "LEFT JOIN label lb ON l.label_id = lb.label_id AND lb.valid_flag = 1 " +
//            "${ew.customSqlSegment}")
//    List<Linkman> selectListWithNames(@Param(Constants.WRAPPER) Wrapper<Linkman> queryWrapper);
    List<Linkman> selectYang(@Param("start") String start, @Param("end") String end);

    List<Linkman> selectNong();
}
